Appendix A: JDBC Driver for Excel, CSV, etc.

DB-Gate is shipped with an internal JDBC driver for MS Excel (97/2000/XP/2003/2007/2010) files, comma-separated values, and ODF spreadsheets (LibreOffice/OpenOffice). Any text file, including XML format files, is read line by line by the driver.

The driver reads a file that resides on the IFS, web, SMB share on the local network, FTP server etc. This data is written to a target file that resides on any DB (or data source) that can be accessed by JDBC on the current system or another IBM i.